Search results 59

  2. Search results
  3. old value
Card image cap
Random Number in SQL

Generate Random number inside SQL using timestamp (GetDate function) One of ...

Jan30
Card image cap
RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

Jan25
Card image cap
PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

Jan22
Card image cap
Converts two bytes to long

Functions to convert two bytes to a numeric value (long), (both little-endian ...

Jan14
Card image cap
SettingRead_JSON

Reads certain value for a certain setting from FullJSONString text block. See ...

Jan8
Card image cap
SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.

2023Nov29
Card image cap
ReverseArray

Reverses order of array. In other words, the upperbound value of an input ...

2023Nov27
Card image cap
Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

2023Feb18
Card image cap
SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

2022Oct17
Card image cap
Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

2022Sep1
Card image cap
SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

2022Aug18
Card image cap
BrowserSetting

Detect Browser setting (type or other info) using MSWC.browsertype object. Old ...

2022Apr29